-- tao mua vu
insert into SEASON(SEASON_NAME,START_DATE,END_DATE) values ('vu xuan 2011','2011-10-10','2011-11-12')
-- insert data for role
insert into ROLE (ROLE_NAME,NOTE) values ('admin',1)
insert into ROLE (ROLE_NAME,NOTE) values ('giam doc',2)
insert into ROLE (ROLE_NAME,NOTE) values ('kiem soat truong',3)
insert into ROLE (ROLE_NAME,NOTE) values ('kiem soat vien',4)
insert into ROLE (ROLE_NAME,NOTE) values ('doi truong',5)
insert into ROLE (ROLE_NAME,NOTE) values ('doi pho',6)
--

select HashBytes('md5', 'anhtv1')
-- create group data
insert into [GROUP](GROUP_NAME,GROUP_CODE,[ADDRESS],NOTE) values ('group2', 'group2', 'ha noi','moi khoi tao test')

-- insert user status
INSERT INTO [TOM_MS].[dbo].[USER_STATUS]([NAME],[NOTE]) VALUES('di lam','di lam')
-- insert user table
insert into [USER](USER_NAME,USER_CODE,PASSWORD,PHONE,ROLE_ID,ADDRESS,FULL_NAME)
 values ('anhtv','anhtv', HashBytes('md5', 'anhtv'),'0989949433',1,'hung yen', 'trang van anh')




